package com.itgaoshu.mapper;

import com.itgaoshu.bean.Bed;
import com.itgaoshu.bean.Departments;
import com.itgaoshu.bean.Doctor;
import com.itgaoshu.bean.Register;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface InHospitalPathMapper{
    //查询住院病人信息
    public List<Register> selRegisters(Register register);
    //回显科室
    @Select("select * from departments")
    public List<Departments> selDepartment();

    //回显医生
    @Select("select * from doctor where departmentId=#{departmentId}")
    public List<Doctor> selDoctor(Integer departmentId);
    //回显床位
    @Select("select * from bed where departmentId=#{departmentId} and state=0")
    public List<Bed> selBed(Integer departmentId);
}
